Diamonds EDA Report

Dataset statistics

Number of variables	10
Number of observations	5000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	1
Duplicate rows (%)	< 0.1%
Total size in memory	390.8 KiB
Average record size in memory	80.0 B

Variable types

Numeric	10

Alerts

Dataset has 1 (< 0.1%) duplicate rows	Duplicates
`carat` is highly overall correlated with `price` and 3 other fields	High correlation
`price` is highly overall correlated with `carat` and 3 other fields	High correlation
`x` is highly overall correlated with `carat` and 3 other fields	High correlation
`y` is highly overall correlated with `carat` and 3 other fields	High correlation
`z` is highly overall correlated with `carat` and 3 other fields	High correlation
`cut` has 158 (3.2%) zeros	Zeros
`color` has 608 (12.2%) zeros	Zeros
`clarity` has 64 (1.3%) zeros	Zeros

Reproduction

Analysis started	2024-04-12 15:40:32.407717
Analysis finished	2024-04-12 15:40:40.468312
Duration	8.06 seconds
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

carat
Real number (ℝ)

HIGH CORRELATION

Distinct	202
Distinct (%)	4.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.794486

Minimum	0.23
Maximum	4.13
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0.23
5-th percentile	0.3
Q1	0.4
median	0.7
Q3	1.04
95-th percentile	1.68
Maximum	4.13
Range	3.9
Interquartile range (IQR)	0.64

Descriptive statistics

Standard deviation	0.46842385
Coefficient of variation (CV)	0.58959358
Kurtosis	1.1529171
Mean	0.794486
Median Absolute Deviation (MAD)	0.32
Skewness	1.0760275
Sum	3972.43
Variance	0.2194209
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.3	250	5.0%
1.01	228	4.6%
0.31	208	4.2%
0.32	192	3.8%
0.7	167	3.3%
0.9	144	2.9%
1	143	2.9%
0.41	125	2.5%
0.4	121	2.4%
0.5	117	2.3%
Other values (192)	3305	66.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.23	37	0.7%
0.24	12	0.2%
0.25	17	0.3%
0.26	30	0.6%
0.27	24	0.5%
0.28	14	0.3%
0.29	12	0.2%
0.3	250	5.0%
0.31	208	4.2%
0.32	192	3.8%

Value	Count	Frequency (%)
4.13	1	< 0.1%
3.01	2	< 0.1%
2.53	1	< 0.1%
2.52	2	< 0.1%
2.51	1	< 0.1%
2.5	2	< 0.1%
2.48	1	< 0.1%
2.47	1	< 0.1%
2.44	1	< 0.1%
2.42	2	< 0.1%

cut
Real number (ℝ)

ZEROS

Distinct	5
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.7614

Minimum	0
Maximum	4
Zeros	158
Zeros (%)	3.2%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	3
Q3	4
95-th percentile	4
Maximum	4
Range	4
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.0353185
Coefficient of variation (CV)	0.37492522
Kurtosis	-0.037128016
Mean	2.7614
Median Absolute Deviation (MAD)	1
Skewness	-0.68950647
Sum	13807
Variance	1.0718844
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=5)

Value	Count	Frequency (%)
3	1992	39.8%
4	1294	25.9%
2	1099	22.0%
1	457	9.1%
0	158	3.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	158	3.2%
1	457	9.1%
2	1099	22.0%
3	1992	39.8%
4	1294	25.9%

Value	Count	Frequency (%)
4	1294	25.9%
3	1992	39.8%
2	1099	22.0%
1	457	9.1%
0	158	3.2%

color
Real number (ℝ)

ZEROS

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.6088

Minimum	0
Maximum	6
Zeros	608
Zeros (%)	12.2%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	4
95-th percentile	5
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.6912524
Coefficient of variation (CV)	0.64828748
Kurtosis	-0.86813777
Mean	2.6088
Median Absolute Deviation (MAD)	1
Skewness	0.16970956
Sum	13044
Variance	2.8603346
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
3	1097	21.9%
1	918	18.4%
2	844	16.9%
4	767	15.3%
0	608	12.2%
5	517	10.3%
6	249	5.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	608	12.2%
1	918	18.4%
2	844	16.9%
3	1097	21.9%
4	767	15.3%
5	517	10.3%
6	249	5.0%

Value	Count	Frequency (%)
6	249	5.0%
5	517	10.3%
4	767	15.3%
3	1097	21.9%
2	844	16.9%
1	918	18.4%
0	608	12.2%

clarity
Real number (ℝ)

ZEROS

Distinct	8
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.0582

Minimum	0
Maximum	7
Zeros	64
Zeros (%)	1.3%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	3
Q3	4
95-th percentile	6
Maximum	7
Range	7
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.6313629
Coefficient of variation (CV)	0.53343893
Kurtosis	-0.41124022
Mean	3.0582
Median Absolute Deviation (MAD)	1
Skewness	0.52772921
Sum	15291
Variance	2.661345
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
2	1194	23.9%
3	1136	22.7%
1	845	16.9%
4	801	16.0%
5	464	9.3%
6	346	6.9%
7	150	3.0%
0	64	1.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	64	1.3%
1	845	16.9%
2	1194	23.9%
3	1136	22.7%
4	801	16.0%
5	464	9.3%
6	346	6.9%
7	150	3.0%

Value	Count	Frequency (%)
7	150	3.0%
6	346	6.9%
5	464	9.3%
4	801	16.0%
3	1136	22.7%
2	1194	23.9%
1	845	16.9%
0	64	1.3%

depth
Real number (ℝ)

Distinct	121
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	61.71166

Minimum	44
Maximum	70.2
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	44
5-th percentile	59.2
Q1	61
median	61.8
Q3	62.5
95-th percentile	63.8
Maximum	70.2
Range	26.2
Interquartile range (IQR)	1.5

Descriptive statistics

Standard deviation	1.4462062
Coefficient of variation (CV)	0.023434894
Kurtosis	7.0815807
Mean	61.71166
Median Absolute Deviation (MAD)	0.7
Skewness	-0.44876851
Sum	308558.3
Variance	2.0915123
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
62	226	4.5%
61.6	203	4.1%
62.1	193	3.9%
62.2	191	3.8%
61.9	186	3.7%
62.3	182	3.6%
61.8	178	3.6%
61.5	177	3.5%
61.7	170	3.4%
61.3	147	2.9%
Other values (111)	3147	62.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
44	1	< 0.1%
53	1	< 0.1%
55.3	1	< 0.1%
55.8	2	< 0.1%
55.9	1	< 0.1%
56.3	3	0.1%
56.5	2	< 0.1%
56.6	1	< 0.1%
56.7	3	0.1%
56.8	3	0.1%

Value	Count	Frequency (%)
70.2	1	< 0.1%
69.8	2	< 0.1%
69.6	1	< 0.1%
68.6	1	< 0.1%
68.5	1	< 0.1%
68.1	1	< 0.1%
67.9	1	< 0.1%
67.8	1	< 0.1%
67.6	2	< 0.1%
67.5	1	< 0.1%

table
Real number (ℝ)

Distinct	78
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	57.44706

Minimum	51.6
Maximum	95
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	51.6
5-th percentile	54
Q1	56
median	57
Q3	59
95-th percentile	61
Maximum	95
Range	43.4
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.2589989
Coefficient of variation (CV)	0.039323142
Kurtosis	15.509318
Mean	57.44706
Median Absolute Deviation (MAD)	1
Skewness	1.4767543
Sum	287235.3
Variance	5.103076
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
56	921	18.4%
57	889	17.8%
58	766	15.3%
59	643	12.9%
55	585	11.7%
60	362	7.2%
54	236	4.7%
61	210	4.2%
62	121	2.4%
63	59	1.2%
Other values (68)	208	4.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
51.6	1	< 0.1%
52	6	0.1%
53	50	1.0%
53.1	1	< 0.1%
53.3	1	< 0.1%
53.4	1	< 0.1%
53.5	2	< 0.1%
53.6	1	< 0.1%
53.7	2	< 0.1%
53.8	5	0.1%

Value	Count	Frequency (%)
95	1	< 0.1%
70	1	< 0.1%
68	1	< 0.1%
67	1	< 0.1%
66	7	0.1%
65.4	1	< 0.1%
65	8	0.2%
64.2	1	< 0.1%
64	26	0.5%
63	59	1.2%

price
Real number (ℝ)

HIGH CORRELATION

Distinct	3179
Distinct (%)	63.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3925.5394

Minimum	-1
Maximum	18787
Zeros	0
Zeros (%)	0.0%
Negative	10
Negative (%)	0.2%
Memory size	39.2 KiB

Quantile statistics

Minimum	-1
5-th percentile	539.95
Q1	936
median	2392.5
Q3	5369.25
95-th percentile	12932.65
Maximum	18787
Range	18788
Interquartile range (IQR)	4433.25

Descriptive statistics

Standard deviation	3975.4521
Coefficient of variation (CV)	1.0127149
Kurtosis	2.0864922
Mean	3925.5394
Median Absolute Deviation (MAD)	1685.5
Skewness	1.589369
Sum	19627697
Variance	15804220
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
605	15	0.3%
776	15	0.3%
765	15	0.3%
561	14	0.3%
698	14	0.3%
625	13	0.3%
526	13	0.3%
544	13	0.3%
552	12	0.2%
878	11	0.2%
Other values (3169)	4865	97.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1	10	0.2%
351	2	< 0.1%
357	2	< 0.1%
361	1	< 0.1%
362	1	< 0.1%
363	1	< 0.1%
367	1	< 0.1%
373	1	< 0.1%
377	1	< 0.1%
383	1	< 0.1%

Value	Count	Frequency (%)
18787	1	< 0.1%
18777	1	< 0.1%
18741	1	< 0.1%
18705	1	< 0.1%
18656	1	< 0.1%
18541	1	< 0.1%
18515	1	< 0.1%
18493	1	< 0.1%
18445	1	< 0.1%
18430	1	< 0.1%

x
Real number (ℝ)

HIGH CORRELATION

Distinct	474
Distinct (%)	9.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.725188

Minimum	0
Maximum	10
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	4.29
Q1	4.7
median	5.69
Q3	6.54
95-th percentile	7.62
Maximum	10
Range	10
Interquartile range (IQR)	1.84

Descriptive statistics

Standard deviation	1.1191564
Coefficient of variation (CV)	0.19547942
Kurtosis	-0.63408023
Mean	5.725188
Median Absolute Deviation (MAD)	0.92
Skewness	0.35052099
Sum	28625.94
Variance	1.2525111
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.38	50	1.0%
4.37	50	1.0%
4.34	46	0.9%
4.35	45	0.9%
4.32	44	0.9%
4.31	40	0.8%
4.4	37	0.7%
4.29	35	0.7%
6.43	34	0.7%
4.39	34	0.7%
Other values (464)	4585	91.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
3.86	2	< 0.1%
3.88	2	< 0.1%
3.89	1	< 0.1%
3.9	2	< 0.1%
3.91	2	< 0.1%
3.92	4	0.1%
3.93	4	0.1%
3.94	6	0.1%
3.95	3	0.1%

Value	Count	Frequency (%)
10	1	< 0.1%
9.44	1	< 0.1%
9.24	1	< 0.1%
8.89	1	< 0.1%
8.87	1	< 0.1%
8.83	1	< 0.1%
8.8	1	< 0.1%
8.72	1	< 0.1%
8.68	1	< 0.1%
8.64	1	< 0.1%

y
Real number (ℝ)

HIGH CORRELATION

Distinct	471
Distinct (%)	9.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.727744

Minimum	0
Maximum	9.85
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	4.29
Q1	4.71
median	5.7
Q3	6.54
95-th percentile	7.5805
Maximum	9.85
Range	9.85
Interquartile range (IQR)	1.83

Descriptive statistics

Standard deviation	1.1121061
Coefficient of variation (CV)	0.19416129
Kurtosis	-0.64940276
Mean	5.727744
Median Absolute Deviation (MAD)	0.92
Skewness	0.34133506
Sum	28638.72
Variance	1.2367801
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.34	52	1.0%
4.39	42	0.8%
4.37	39	0.8%
4.35	39	0.8%
4.41	39	0.8%
4.32	39	0.8%
4.38	37	0.7%
4.33	36	0.7%
4.36	35	0.7%
4.4	35	0.7%
Other values (461)	4607	92.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
3.84	1	< 0.1%
3.89	2	< 0.1%
3.9	2	< 0.1%
3.92	1	< 0.1%
3.93	1	< 0.1%
3.94	2	< 0.1%
3.95	6	0.1%
3.96	5	0.1%
3.97	4	0.1%

Value	Count	Frequency (%)
9.85	1	< 0.1%
9.37	1	< 0.1%
9.13	1	< 0.1%
8.93	1	< 0.1%
8.87	1	< 0.1%
8.83	1	< 0.1%
8.78	1	< 0.1%
8.66	1	< 0.1%
8.65	1	< 0.1%
8.62	1	< 0.1%

z
Real number (ℝ)

HIGH CORRELATION

Distinct	304
Distinct (%)	6.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.533076

Minimum	0
Maximum	6.43
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	2.65
Q1	2.9
median	3.53
Q3	4.03
95-th percentile	4.68
Maximum	6.43
Range	6.43
Interquartile range (IQR)	1.13

Descriptive statistics

Standard deviation	0.69033367
Coefficient of variation (CV)	0.19539168
Kurtosis	-0.59720822
Mean	3.533076
Median Absolute Deviation (MAD)	0.57
Skewness	0.34845832
Sum	17665.38
Variance	0.47656057
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.69	77	1.5%
2.73	72	1.4%
2.72	72	1.4%
2.7	66	1.3%
2.71	66	1.3%
2.68	65	1.3%
2.67	59	1.2%
2.74	58	1.2%
3.99	56	1.1%
4.02	56	1.1%
Other values (294)	4353	87.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1.41	1	< 0.1%
2.35	1	< 0.1%
2.37	1	< 0.1%
2.38	1	< 0.1%
2.39	2	< 0.1%
2.4	2	< 0.1%
2.41	1	< 0.1%
2.42	4	0.1%
2.43	6	0.1%

Value	Count	Frequency (%)
6.43	1	< 0.1%
6.16	1	< 0.1%
5.73	1	< 0.1%
5.62	1	< 0.1%
5.6	1	< 0.1%
5.53	1	< 0.1%
5.43	1	< 0.1%
5.42	1	< 0.1%
5.41	1	< 0.1%
5.39	1	< 0.1%

Auto

Heatmap
Table

	carat	clarity	color	cut	depth	price	table	x	y	z
carat	1.000	-0.346	0.243	0.020	-0.002	0.958	0.205	0.995	0.995	0.993
clarity	-0.346	1.000	0.042	0.042	-0.071	-0.179	-0.148	-0.341	-0.336	-0.347
color	0.243	0.042	1.000	0.032	0.027	0.141	0.035	0.238	0.239	0.243
cut	0.020	0.042	0.032	1.000	-0.289	0.039	0.073	0.040	0.023	-0.007
depth	-0.002	-0.071	0.027	-0.289	1.000	-0.020	-0.264	-0.057	-0.058	0.073
price	0.958	-0.179	0.141	0.039	-0.020	1.000	0.182	0.957	0.957	0.952
table	0.205	-0.148	0.035	0.073	-0.264	0.182	1.000	0.213	0.205	0.169
x	0.995	-0.341	0.238	0.040	-0.057	0.957	0.213	1.000	0.998	0.988
y	0.995	-0.336	0.239	0.023	-0.058	0.957	0.205	0.998	1.000	0.987
z	0.993	-0.347	0.243	-0.007	0.073	0.952	0.169	0.988	0.987	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	carat	cut	color	clarity	depth	table	price	x	y	z
0	1.10	3	4	1	62.0	55.0	4733	6.61	6.65	4.11
1	1.29	3	4	2	62.6	56.0	6424	6.96	6.93	4.35
2	1.20	4	5	2	61.1	58.0	5510	6.88	6.80	4.18
3	1.50	3	2	2	60.9	56.0	8770	7.43	7.36	4.50
4	0.90	2	2	3	61.7	57.0	4493	6.17	6.21	3.82
5	0.32	3	3	7	61.7	54.0	918	4.39	4.42	2.72
6	0.30	2	4	7	62.9	58.0	789	4.26	4.29	2.69
7	0.61	3	1	5	61.3	54.0	2823	5.51	5.59	3.40
8	2.01	4	3	1	61.2	57.2	18705	8.08	8.14	4.97
9	0.31	3	5	4	61.2	55.0	507	4.37	4.39	2.68

	carat	cut	color	clarity	depth	table	price	x	y	z
4990	0.73	3	2	6	61.9	56.0	5154	5.75	5.79	3.57
4991	0.42	3	3	3	62.2	54.0	847	4.80	4.82	2.99
4992	0.72	3	5	5	61.0	57.0	2602	5.81	5.84	3.55
4993	1.00	2	1	1	59.6	59.0	4321	6.48	6.51	3.87
4994	0.71	3	3	4	61.5	55.0	3431	5.72	5.77	3.54
4995	0.38	3	4	5	62.3	53.3	832	4.65	4.69	2.91
4996	0.33	4	3	5	61.3	59.0	927	4.45	4.42	2.72
4997	1.25	3	6	5	62.1	56.0	5980	6.81	6.84	4.24
4998	0.31	4	2	3	62.9	58.0	802	4.31	4.27	2.70
4999	0.30	3	4	6	61.2	57.0	655	4.30	4.39	2.66

Most frequently occurring

	carat	cut	color	clarity	depth	table	price	x	y	z	# duplicates
0	0.31	4	1	3	61.6	59.0	872	4.35	4.32	2.67	2

Overview

Variables

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring